Mega Code Archive

Categories
1) Android
2) ASP.Net
3) ASP.Net Tutorial
4) C
5) C Tutorial
6) C#
7) C# Book
8) C# by API
9) C# Tutorial
10) C++
11) C++ Tutorial
12) Delphi
13) Flash ActionScript
14) Flex
15) Java
16) Java Book
17) Java by API
18) Java Tutorial
19) JavaScript DHTML
20) JavaScript Reference
21) JavaScript Tutorial
22) MSOfficeExcel 2007 Tutorial
23) MSOfficePowerPoint 2007 Tutorial
24) MSOfficeWord 2007 Tutorial
25) MSSQL
26) MSSQL Tutorial
27) MySQL
28) MySQL Tutorial
29) Oracle PLSQL
30) Oracle PLSQL Tutorial
31) Perl
32) Php
33) PostgreSQL
34) Python
35) Python Tutorial
36) Ruby
37) Silverlight
38) VB.Net
39) VB.Net by API
40) VB.Net Tutorial
41) Visual C++ .NET
42) VisualBasic Script
43) XML
44) XML Tutorial

 

MSOfficeExcel 2007 Tutorial
1) Chart
2) Collaboration
3) Data Analysis
4) Database Functions
5) Date Time Functions
6) Editing
7) Engineering Functions
8) Format Style
9) Formula
10) Information Functions
11) Introduction
12) Logical Functions
13) Lookup Reference Functions
14) Macro Activex Add In
15) Math Trigonometry Functions
16) Pivottable Pivotchart
17) Security
18) Statistical Functions
19) Table
20) Text Functions
21) Wordart Clip Art Shape Picture
22) Workbook Worksheet

Introduction
1) Add a Ribbon button or group to Quick Access Toolbar
2) Add or remove a common button in Quick Access Toolbar
3) Add or Remove Items from the Status Bar
4) All dialog boxes contain the same types of controls
5) Arrange or Switch Between Windows
6) Change the View with statusbar
7) Change the View with View tab
8) Check Help Connection Status
9) Choose a Command from the Office Menu
10) Choosing Dialog Box Options
11) Compare Windows Side By Side
12) Convert a Excel 97-2003 Workbook to Excel 2007
13) Create a Custom View
14) Create a program shortcut from the Start menu to the desktop for Excel
15) Customize the Quick Access Toolbar
16) Diagnose and Repair Problems
17) Display KeyTips
18) Enable Live Preview
19) Excel provides three types of tabs on the Ribbon
20) Find Online Office Information
21) Get command help
22) Get Excel Updates on the Web
23) Insert window panes
24) Live Preview
25) Minimize the Ribbon
26) Modify Message Bar Security Options
27) Move the Quick Access Toolbar to another location
28) Navigate through dialog
29) Office checks compatibility for non supported features in earlier versions
30) Remove a button or group in Quick Access Toolbar
31) Rest the Quick Access Toolbar to its original state
32) Save a Workspace Layout of Windows
33) Search for Help
34) Select ScreenTip style
35) Set Developer Options
36) Set your name to appear in Properties, and review comments
37) Show a Custom View
38) Show Mini Toolbar on Selection
39) Show or Hide Workbook Elements
40) Start Excel from the Start Menu
41) The Excel commands are organized in groups on the Ribbon, Office menu , Quick Access Toolbar, and Mini-Toolbar
42) The Ribbon replaces menus, toolbars, and most of the task panes found in Excel 2003
43) To delete a view
44) To minimize the Ribbon, double-click the name of the tab
45) Turn off ScreenTips or change the display
46) Using the Help Viewer to Get Answers
47) Using the Status Bar
48) View a workbook in full screen without the Ribbon, tabs, and toolbars
49) Work with Task and Window Panes